Dataset statistics
| Number of variables | 18 |
|---|---|
| Number of observations | 710839 |
| Missing cells | 1633088 |
| Missing cells (%) | 12.8% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 437.5 MiB |
| Average record size in memory | 645.3 B |
Variable types
| NUM | 11 |
|---|---|
| CAT | 7 |
Start Time has a high cardinality: 2399 distinct values | High cardinality |
End Time has a high cardinality: 2442 distinct values | High cardinality |
Start Centroid Location has a high cardinality: 275 distinct values | High cardinality |
End Centroid Location has a high cardinality: 293 distinct values | High cardinality |
Start Centroid Latitude is highly correlated with Start Community Area Number | High correlation |
Start Community Area Number is highly correlated with Start Centroid Latitude | High correlation |
Start Census Tract has 328202 (46.2%) missing values | Missing |
End Census Tract has 328364 (46.2%) missing values | Missing |
Start Community Area Number has 97389 (13.7%) missing values | Missing |
End Community Area Number has 97916 (13.8%) missing values | Missing |
Start Community Area Name has 97389 (13.7%) missing values | Missing |
End Community Area Name has 97916 (13.8%) missing values | Missing |
Start Centroid Latitude has 97388 (13.7%) missing values | Missing |
Start Centroid Longitude has 97388 (13.7%) missing values | Missing |
Start Centroid Location has 97388 (13.7%) missing values | Missing |
End Centroid Latitude has 97916 (13.8%) missing values | Missing |
End Centroid Longitude has 97916 (13.8%) missing values | Missing |
End Centroid Location has 97916 (13.8%) missing values | Missing |
Trip Distance is highly skewed (γ1 = 130.443317) | Skewed |
Accuracy is highly skewed (γ1 = 387.4378225) | Skewed |
Trip ID has unique values | Unique |
Trip Distance has 51958 (7.3%) zeros | Zeros |
Accuracy has 128767 (18.1%) zeros | Zeros |
Reproduction
| Analysis started | 2020-12-12 22:02:17.473125 |
|---|---|
| Analysis finished | 2020-12-12 22:03:07.379571 |
| Duration | 49.91 seconds |
| Software version | pandas-profiling v2.9.0 |
| Download configuration | config.yaml |
| Distinct | 710839 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.4 MiB |
| be5fe66c-1c3a-48db-8c14-0afc667f3011 | 1 |
|---|---|
| c0bf6519-b061-40ce-86c7-85e247a3ac06 | 1 |
| 1ad743de-6a32-43fa-b1a7-0ec2d5e5b198 | 1 |
| e12f7856-e81b-55e7-9d8d-528e9febf17e | 1 |
| 459978b1-21c2-46a4-80c6-361ff33ffbda | 1 |
| Other values (710834) |
| Value | Count | Frequency (%) | |
| be5fe66c-1c3a-48db-8c14-0afc667f3011 | 1 | < 0.1% | |
| c0bf6519-b061-40ce-86c7-85e247a3ac06 | 1 | < 0.1% | |
| 1ad743de-6a32-43fa-b1a7-0ec2d5e5b198 | 1 | < 0.1% | |
| e12f7856-e81b-55e7-9d8d-528e9febf17e | 1 | < 0.1% | |
| 459978b1-21c2-46a4-80c6-361ff33ffbda | 1 | < 0.1% | |
| 124c35db-6992-c652-124c-35db6992c652 | 1 | < 0.1% | |
| 81620dde-5b1e-4d80-b405-661731798261 | 1 | < 0.1% | |
| 15ffe587-dd17-51cf-aae5-64e9807eab3c | 1 | < 0.1% | |
| 120b362f-0037-02d8-120b-362f003702d8 | 1 | < 0.1% | |
| 8eb42b08-a38e-45a5-ba89-db56dd0167de | 1 | < 0.1% | |
| 1adcacc1-2a67-52c9-bc45-3a904f77c9fd | 1 | < 0.1% | |
| 1211aa58-8e64-3ba6-1211-aa588e643ba6 | 1 | < 0.1% | |
| 1bddd05f-7010-4987-ba8f-73a15f008c58 | 1 | < 0.1% | |
| 55f7d861-3c14-5ea1-a884-5c4ddac3f00f | 1 | < 0.1% | |
| c360a98d-4c93-46fd-afe6-fb4c9f0118dc | 1 | < 0.1% | |
| 46b8b54a-47f8-47dd-b2c2-bf96793e1a4e | 1 | < 0.1% | |
| 429e4057-6de0-4637-b36d-dd4cf7b44983 | 1 | < 0.1% | |
| 7f626360-c66e-447e-8024-6a5f6452b98e | 1 | < 0.1% | |
| 48abfbd0-9c57-400d-be48-1100fdc50e35 | 1 | < 0.1% | |
| 38fda097-d534-4dbf-aee1-be959d21bf3d | 1 | < 0.1% | |
| b7361101-8b44-5f41-853f-15ce4bcccb8f | 1 | < 0.1% | |
| 11d96b68-5d67-42d4-11d9-6b685d6742d4 | 1 | < 0.1% | |
| 72fbaf8e-7e17-415f-a7fc-a38c40a9e1cf | 1 | < 0.1% | |
| 11f0fca6-5ec1-0ef0-11f0-fca65ec10ef0 | 1 | < 0.1% | |
| 80fff13f-cc71-40b8-b537-6d801bbb5cf2 | 1 | < 0.1% | |
| Other values (710814) | 710814 | > 99.9% |
Frequencies of value counts
Unique
| Unique | 710839 ? |
|---|---|
| Unique (%) | 100.0% |
Histogram of lengths of the category
Length
| Max length | 36 |
|---|---|
| Median length | 36 |
| Mean length | 36 |
| Min length | 36 |
Most occurring characters
| Value | Count | Frequency (%) | |
| - | 2843356 | 11.1% | |
| 4 | 1741942 | 6.8% | |
| 1 | 1639342 | 6.4% | |
| b | 1515133 | 5.9% | |
| 5 | 1477422 | 5.8% | |
| 2 | 1474344 | 5.8% | |
| 8 | 1439248 | 5.6% | |
| a | 1431872 | 5.6% | |
| 9 | 1407545 | 5.5% | |
| 0 | 1349746 | 5.3% | |
| e | 1348788 | 5.3% | |
| c | 1332458 | 5.2% | |
| 3 | 1329130 | 5.2% | |
| 6 | 1328132 | 5.2% | |
| d | 1318730 | 5.2% | |
| f | 1311526 | 5.1% | |
| 7 | 1301490 | 5.1% |
Most occurring categories
| Value | Count | Frequency (%) | |
| Decimal Number | 14488341 | 56.6% | |
| Lowercase Letter | 8258507 | 32.3% | |
| Dash Punctuation | 2843356 | 11.1% |
Most frequent Decimal Number characters
| Value | Count | Frequency (%) | |
| 4 | 1741942 | 12.0% | |
| 1 | 1639342 | 11.3% | |
| 5 | 1477422 | 10.2% | |
| 2 | 1474344 | 10.2% | |
| 8 | 1439248 | 9.9% | |
| 9 | 1407545 | 9.7% | |
| 0 | 1349746 | 9.3% | |
| 3 | 1329130 | 9.2% | |
| 6 | 1328132 | 9.2% | |
| 7 | 1301490 | 9.0% |
Most frequent Lowercase Letter characters
| Value | Count | Frequency (%) | |
| b | 1515133 | 18.3% | |
| a | 1431872 | 17.3% | |
| e | 1348788 | 16.3% | |
| c | 1332458 | 16.1% | |
| d | 1318730 | 16.0% | |
| f | 1311526 | 15.9% |
Most frequent Dash Punctuation characters
| Value | Count | Frequency (%) | |
| - | 2843356 | 100.0% |
Most occurring scripts
| Value | Count | Frequency (%) | |
| Common | 17331697 | 67.7% | |
| Latin | 8258507 | 32.3% |
Most frequent Common characters
| Value | Count | Frequency (%) | |
| - | 2843356 | 16.4% | |
| 4 | 1741942 | 10.1% | |
| 1 | 1639342 | 9.5% | |
| 5 | 1477422 | 8.5% | |
| 2 | 1474344 | 8.5% | |
| 8 | 1439248 | 8.3% | |
| 9 | 1407545 | 8.1% | |
| 0 | 1349746 | 7.8% | |
| 3 | 1329130 | 7.7% | |
| 6 | 1328132 | 7.7% | |
| 7 | 1301490 | 7.5% |
Most frequent Latin characters
| Value | Count | Frequency (%) | |
| b | 1515133 | 18.3% | |
| a | 1431872 | 17.3% | |
| e | 1348788 | 16.3% | |
| c | 1332458 | 16.1% | |
| d | 1318730 | 16.0% | |
| f | 1311526 | 15.9% |
Most occurring blocks
| Value | Count | Frequency (%) | |
| ASCII | 25590204 | 100.0% |
Most frequent ASCII characters
| Value | Count | Frequency (%) | |
| - | 2843356 | 11.1% | |
| 4 | 1741942 | 6.8% | |
| 1 | 1639342 | 6.4% | |
| b | 1515133 | 5.9% | |
| 5 | 1477422 | 5.8% | |
| 2 | 1474344 | 5.8% | |
| 8 | 1439248 | 5.6% | |
| a | 1431872 | 5.6% | |
| 9 | 1407545 | 5.5% | |
| 0 | 1349746 | 5.3% | |
| e | 1348788 | 5.3% | |
| c | 1332458 | 5.2% | |
| 3 | 1329130 | 5.2% | |
| 6 | 1328132 | 5.2% | |
| d | 1318730 | 5.2% | |
| f | 1311526 | 5.1% | |
| 7 | 1301490 | 5.1% |
| Distinct | 2399 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.4 MiB |
| 06/22/2019 03:00:00 PM | 1134 |
|---|---|
| 06/28/2019 05:00:00 PM | 1111 |
| 06/22/2019 02:00:00 PM | 1104 |
| 06/21/2019 05:00:00 PM | 1059 |
| 07/11/2019 06:00:00 PM | 1049 |
| Other values (2394) |
| Value | Count | Frequency (%) | |
| 06/22/2019 03:00:00 PM | 1134 | 0.2% | |
| 06/28/2019 05:00:00 PM | 1111 | 0.2% | |
| 06/22/2019 02:00:00 PM | 1104 | 0.2% | |
| 06/21/2019 05:00:00 PM | 1059 | 0.1% | |
| 07/11/2019 06:00:00 PM | 1049 | 0.1% | |
| 06/22/2019 04:00:00 PM | 1033 | 0.1% | |
| 07/06/2019 05:00:00 PM | 1021 | 0.1% | |
| 06/24/2019 06:00:00 PM | 1003 | 0.1% | |
| 06/28/2019 06:00:00 PM | 992 | 0.1% | |
| 06/21/2019 06:00:00 PM | 986 | 0.1% | |
| 06/22/2019 05:00:00 PM | 963 | 0.1% | |
| 07/03/2019 05:00:00 PM | 961 | 0.1% | |
| 06/22/2019 01:00:00 PM | 958 | 0.1% | |
| 07/11/2019 07:00:00 PM | 958 | 0.1% | |
| 06/26/2019 06:00:00 PM | 948 | 0.1% | |
| 06/25/2019 06:00:00 PM | 943 | 0.1% | |
| 07/07/2019 04:00:00 PM | 942 | 0.1% | |
| 07/12/2019 06:00:00 PM | 942 | 0.1% | |
| 06/18/2019 06:00:00 PM | 935 | 0.1% | |
| 06/29/2019 04:00:00 PM | 929 | 0.1% | |
| 06/20/2019 06:00:00 PM | 927 | 0.1% | |
| 06/23/2019 01:00:00 PM | 922 | 0.1% | |
| 06/16/2019 03:00:00 PM | 921 | 0.1% | |
| 06/20/2019 05:00:00 PM | 914 | 0.1% | |
| 06/26/2019 05:00:00 PM | 913 | 0.1% | |
| Other values (2374) | 686271 | 96.5% |
Frequencies of value counts
Unique
| Unique | 21 ? |
|---|---|
| Unique (%) | < 0.1% |
Histogram of lengths of the category
Length
| Max length | 22 |
|---|---|
| Median length | 22 |
| Mean length | 22 |
| Min length | 22 |
Most occurring characters
| Value | Count | Frequency (%) | |
| 0 | 5148777 | 32.9% | |
| / | 1421678 | 9.1% | |
| 1421678 | 9.1% | ||
| : | 1421678 | 9.1% | |
| 1 | 1233411 | 7.9% | |
| 2 | 1131268 | 7.2% | |
| 9 | 1006226 | 6.4% | |
| M | 710839 | 4.5% | |
| P | 598011 | 3.8% | |
| 7 | 372910 | 2.4% | |
| 8 | 335500 | 2.1% | |
| 6 | 283775 | 1.8% | |
| 3 | 161158 | 1.0% | |
| 5 | 148605 | 1.0% | |
| 4 | 130116 | 0.8% | |
| A | 112828 | 0.7% |
Most occurring categories
| Value | Count | Frequency (%) | |
| Decimal Number | 9951746 | 63.6% | |
| Other Punctuation | 2843356 | 18.2% | |
| Space Separator | 1421678 | 9.1% | |
| Uppercase Letter | 1421678 | 9.1% |
Most frequent Decimal Number characters
| Value | Count | Frequency (%) | |
| 0 | 5148777 | 51.7% | |
| 1 | 1233411 | 12.4% | |
| 2 | 1131268 | 11.4% | |
| 9 | 1006226 | 10.1% | |
| 7 | 372910 | 3.7% | |
| 8 | 335500 | 3.4% | |
| 6 | 283775 | 2.9% | |
| 3 | 161158 | 1.6% | |
| 5 | 148605 | 1.5% | |
| 4 | 130116 | 1.3% |
Most frequent Other Punctuation characters
| Value | Count | Frequency (%) | |
| / | 1421678 | 50.0% | |
| : | 1421678 | 50.0% |
Most frequent Space Separator characters
| Value | Count | Frequency (%) | |
| 1421678 | 100.0% |
Most frequent Uppercase Letter characters
| Value | Count | Frequency (%) | |
| M | 710839 | 50.0% | |
| P | 598011 | 42.1% | |
| A | 112828 | 7.9% |
Most occurring scripts
| Value | Count | Frequency (%) | |
| Common | 14216780 | 90.9% | |
| Latin | 1421678 | 9.1% |
Most frequent Common characters
| Value | Count | Frequency (%) | |
| 0 | 5148777 | 36.2% | |
| / | 1421678 | 10.0% | |
| 1421678 | 10.0% | ||
| : | 1421678 | 10.0% | |
| 1 | 1233411 | 8.7% | |
| 2 | 1131268 | 8.0% | |
| 9 | 1006226 | 7.1% | |
| 7 | 372910 | 2.6% | |
| 8 | 335500 | 2.4% | |
| 6 | 283775 | 2.0% | |
| 3 | 161158 | 1.1% | |
| 5 | 148605 | 1.0% | |
| 4 | 130116 | 0.9% |
Most frequent Latin characters
| Value | Count | Frequency (%) | |
| M | 710839 | 50.0% | |
| P | 598011 | 42.1% | |
| A | 112828 | 7.9% |
Most occurring blocks
| Value | Count | Frequency (%) | |
| ASCII | 15638458 | 100.0% |
Most frequent ASCII characters
| Value | Count | Frequency (%) | |
| 0 | 5148777 | 32.9% | |
| / | 1421678 | 9.1% | |
| 1421678 | 9.1% | ||
| : | 1421678 | 9.1% | |
| 1 | 1233411 | 7.9% | |
| 2 | 1131268 | 7.2% | |
| 9 | 1006226 | 6.4% | |
| M | 710839 | 4.5% | |
| P | 598011 | 3.8% | |
| 7 | 372910 | 2.4% | |
| 8 | 335500 | 2.1% | |
| 6 | 283775 | 1.8% | |
| 3 | 161158 | 1.0% | |
| 5 | 148605 | 1.0% | |
| 4 | 130116 | 0.8% | |
| A | 112828 | 0.7% |
| Distinct | 2442 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.4 MiB |
| 06/22/2019 03:00:00 PM | 1113 |
|---|---|
| 06/22/2019 04:00:00 PM | 1074 |
| 06/28/2019 05:00:00 PM | 1070 |
| 06/22/2019 02:00:00 PM | 1040 |
| 06/21/2019 05:00:00 PM | 1040 |
| Other values (2437) |
| Value | Count | Frequency (%) | |
| 06/22/2019 03:00:00 PM | 1113 | 0.2% | |
| 06/22/2019 04:00:00 PM | 1074 | 0.2% | |
| 06/28/2019 05:00:00 PM | 1070 | 0.2% | |
| 06/22/2019 02:00:00 PM | 1040 | 0.1% | |
| 06/21/2019 05:00:00 PM | 1040 | 0.1% | |
| 06/28/2019 06:00:00 PM | 1032 | 0.1% | |
| 07/11/2019 06:00:00 PM | 1025 | 0.1% | |
| 06/21/2019 06:00:00 PM | 1023 | 0.1% | |
| 07/06/2019 05:00:00 PM | 984 | 0.1% | |
| 06/24/2019 06:00:00 PM | 981 | 0.1% | |
| 07/11/2019 07:00:00 PM | 969 | 0.1% | |
| 06/18/2019 06:00:00 PM | 960 | 0.1% | |
| 06/22/2019 05:00:00 PM | 952 | 0.1% | |
| 06/20/2019 06:00:00 PM | 948 | 0.1% | |
| 06/26/2019 06:00:00 PM | 936 | 0.1% | |
| 07/03/2019 05:00:00 PM | 931 | 0.1% | |
| 07/06/2019 06:00:00 PM | 923 | 0.1% | |
| 07/07/2019 04:00:00 PM | 922 | 0.1% | |
| 06/16/2019 03:00:00 PM | 913 | 0.1% | |
| 06/21/2019 07:00:00 PM | 911 | 0.1% | |
| 07/03/2019 04:00:00 PM | 910 | 0.1% | |
| 07/12/2019 06:00:00 PM | 909 | 0.1% | |
| 06/27/2019 06:00:00 PM | 909 | 0.1% | |
| 06/29/2019 05:00:00 PM | 909 | 0.1% | |
| 07/12/2019 07:00:00 PM | 907 | 0.1% | |
| Other values (2417) | 686548 | 96.6% |
Frequencies of value counts
Unique
| Unique | 58 ? |
|---|---|
| Unique (%) | < 0.1% |
Histogram of lengths of the category
Length
| Max length | 22 |
|---|---|
| Median length | 22 |
| Mean length | 22 |
| Min length | 22 |
Most occurring characters
| Value | Count | Frequency (%) | |
| 0 | 5151509 | 32.9% | |
| / | 1421678 | 9.1% | |
| 1421678 | 9.1% | ||
| : | 1421678 | 9.1% | |
| 1 | 1235400 | 7.9% | |
| 2 | 1128956 | 7.2% | |
| 9 | 1009513 | 6.5% | |
| M | 710839 | 4.5% | |
| P | 602772 | 3.9% | |
| 7 | 373169 | 2.4% | |
| 8 | 335722 | 2.1% | |
| 6 | 283736 | 1.8% | |
| 3 | 159709 | 1.0% | |
| 5 | 145886 | 0.9% | |
| 4 | 128146 | 0.8% | |
| A | 108067 | 0.7% |
Most occurring categories
| Value | Count | Frequency (%) | |
| Decimal Number | 9951746 | 63.6% | |
| Other Punctuation | 2843356 | 18.2% | |
| Space Separator | 1421678 | 9.1% | |
| Uppercase Letter | 1421678 | 9.1% |
Most frequent Decimal Number characters
| Value | Count | Frequency (%) | |
| 0 | 5151509 | 51.8% | |
| 1 | 1235400 | 12.4% | |
| 2 | 1128956 | 11.3% | |
| 9 | 1009513 | 10.1% | |
| 7 | 373169 | 3.7% | |
| 8 | 335722 | 3.4% | |
| 6 | 283736 | 2.9% | |
| 3 | 159709 | 1.6% | |
| 5 | 145886 | 1.5% | |
| 4 | 128146 | 1.3% |
Most frequent Other Punctuation characters
| Value | Count | Frequency (%) | |
| / | 1421678 | 50.0% | |
| : | 1421678 | 50.0% |
Most frequent Space Separator characters
| Value | Count | Frequency (%) | |
| 1421678 | 100.0% |
Most frequent Uppercase Letter characters
| Value | Count | Frequency (%) | |
| M | 710839 | 50.0% | |
| P | 602772 | 42.4% | |
| A | 108067 | 7.6% |
Most occurring scripts
| Value | Count | Frequency (%) | |
| Common | 14216780 | 90.9% | |
| Latin | 1421678 | 9.1% |
Most frequent Common characters
| Value | Count | Frequency (%) | |
| 0 | 5151509 | 36.2% | |
| / | 1421678 | 10.0% | |
| 1421678 | 10.0% | ||
| : | 1421678 | 10.0% | |
| 1 | 1235400 | 8.7% | |
| 2 | 1128956 | 7.9% | |
| 9 | 1009513 | 7.1% | |
| 7 | 373169 | 2.6% | |
| 8 | 335722 | 2.4% | |
| 6 | 283736 | 2.0% | |
| 3 | 159709 | 1.1% | |
| 5 | 145886 | 1.0% | |
| 4 | 128146 | 0.9% |
Most frequent Latin characters
| Value | Count | Frequency (%) | |
| M | 710839 | 50.0% | |
| P | 602772 | 42.4% | |
| A | 108067 | 7.6% |
Most occurring blocks
| Value | Count | Frequency (%) | |
| ASCII | 15638458 | 100.0% |
Most frequent ASCII characters
| Value | Count | Frequency (%) | |
| 0 | 5151509 | 32.9% | |
| / | 1421678 | 9.1% | |
| 1421678 | 9.1% | ||
| : | 1421678 | 9.1% | |
| 1 | 1235400 | 7.9% | |
| 2 | 1128956 | 7.2% | |
| 9 | 1009513 | 6.5% | |
| M | 710839 | 4.5% | |
| P | 602772 | 3.9% | |
| 7 | 373169 | 2.4% | |
| 8 | 335722 | 2.1% | |
| 6 | 283736 | 1.8% | |
| 3 | 159709 | 1.0% | |
| 5 | 145886 | 0.9% | |
| 4 | 128146 | 0.8% | |
| A | 108067 | 0.7% |
| Distinct | 15594 |
|---|---|
| Distinct (%) | 2.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11977.20099 |
|---|---|
| Minimum | 0 |
| Maximum | 215653491 |
| Zeros | 51958 |
| Zeros (%) | 7.3% |
| Memory size | 5.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 612 |
| median | 1366 |
| Q3 | 2773 |
| 95-th percentile | 6942 |
| Maximum | 215653491 |
| Range | 215653491 |
| Interquartile range (IQR) | 2161 |
Descriptive statistics
| Standard deviation | 617755.6435 |
|---|---|
| Coefficient of variation (CV) | 51.57763021 |
| Kurtosis | 29504.65111 |
| Mean | 11977.20099 |
| Median Absolute Deviation (MAD) | 937 |
| Skewness | 130.443317 |
| Sum | 8513861572 |
| Variance | 3.81622035e+11 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0 | 51958 | 7.3% | |
| 1000 | 9444 | 1.3% | |
| 2000 | 6294 | 0.9% | |
| 3000 | 4320 | 0.6% | |
| 16 | 3733 | 0.5% | |
| 4000 | 3050 | 0.4% | |
| 5000 | 2084 | 0.3% | |
| 32 | 1903 | 0.3% | |
| 6000 | 1622 | 0.2% | |
| 692 | 1524 | 0.2% | |
| 724 | 1522 | 0.2% | |
| 740 | 1511 | 0.2% | |
| 788 | 1488 | 0.2% | |
| 675 | 1488 | 0.2% | |
| 756 | 1483 | 0.2% | |
| 772 | 1477 | 0.2% | |
| 820 | 1473 | 0.2% | |
| 708 | 1472 | 0.2% | |
| 563 | 1467 | 0.2% | |
| 643 | 1464 | 0.2% | |
| 659 | 1460 | 0.2% | |
| 852 | 1449 | 0.2% | |
| 804 | 1426 | 0.2% | |
| 611 | 1424 | 0.2% | |
| 885 | 1423 | 0.2% | |
| Other values (15569) | 602880 | 84.8% |
| Value | Count | Frequency (%) | |
| 0 | 51958 | 7.3% | |
| 1 | 346 | < 0.1% | |
| 2 | 395 | 0.1% | |
| 3 | 473 | 0.1% | |
| 4 | 467 | 0.1% | |
| 5 | 420 | 0.1% | |
| 6 | 432 | 0.1% | |
| 7 | 411 | 0.1% | |
| 8 | 406 | 0.1% | |
| 9 | 384 | 0.1% |
| Value | Count | Frequency (%) | |
| 215653491 | 1 | < 0.1% | |
| 129393334 | 1 | < 0.1% | |
| 107883974 | 1 | < 0.1% | |
| 97040904 | 1 | < 0.1% | |
| 86300601 | 1 | < 0.1% | |
| 86289457 | 1 | < 0.1% | |
| 64761919 | 1 | < 0.1% | |
| 64745923 | 1 | < 0.1% | |
| 64730012 | 1 | < 0.1% | |
| 64726562 | 1 | < 0.1% |
Trip Duration
Real number (ℝ)
| Distinct | 9473 |
|---|---|
| Distinct (%) | 1.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 722.2299297 |
|---|---|
| Minimum | -1642 |
| Maximum | 110628 |
| Zeros | 1810 |
| Zeros (%) | 0.3% |
| Memory size | 5.4 MiB |
Quantile statistics
| Minimum | -1642 |
|---|---|
| 5-th percentile | 7 |
| Q1 | 189 |
| median | 407 |
| Q3 | 829 |
| 95-th percentile | 2297 |
| Maximum | 110628 |
| Range | 112270 |
| Interquartile range (IQR) | 640 |
Descriptive statistics
| Standard deviation | 1312.577602 |
|---|---|
| Coefficient of variation (CV) | 1.817395747 |
| Kurtosis | 510.0808989 |
| Mean | 722.2299297 |
| Median Absolute Deviation (MAD) | 272 |
| Skewness | 14.6395409 |
| Sum | 513389201 |
| Variance | 1722859.962 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 4 | 6585 | 0.9% | |
| 5 | 6480 | 0.9% | |
| 6 | 5778 | 0.8% | |
| 3 | 5515 | 0.8% | |
| 7 | 5016 | 0.7% | |
| 2 | 4347 | 0.6% | |
| 8 | 4230 | 0.6% | |
| 9 | 3756 | 0.5% | |
| 10 | 3268 | 0.5% | |
| 11 | 2860 | 0.4% | |
| 12 | 2541 | 0.4% | |
| 1 | 2443 | 0.3% | |
| 13 | 2226 | 0.3% | |
| 14 | 1938 | 0.3% | |
| 0 | 1810 | 0.3% | |
| 15 | 1740 | 0.2% | |
| 16 | 1555 | 0.2% | |
| 17 | 1492 | 0.2% | |
| 216 | 1249 | 0.2% | |
| 211 | 1227 | 0.2% | |
| 18 | 1203 | 0.2% | |
| 201 | 1199 | 0.2% | |
| 221 | 1181 | 0.2% | |
| 186 | 1180 | 0.2% | |
| 171 | 1179 | 0.2% | |
| Other values (9448) | 638841 | 89.9% |
| Value | Count | Frequency (%) | |
| -1642 | 1 | < 0.1% | |
| -809 | 1 | < 0.1% | |
| -690 | 1 | < 0.1% | |
| -665 | 1 | < 0.1% | |
| -611 | 1 | < 0.1% | |
| -555 | 1 | < 0.1% | |
| 0 | 1810 | 0.3% | |
| 1 | 2443 | 0.3% | |
| 2 | 4347 | 0.6% | |
| 3 | 5515 | 0.8% |
| Value | Count | Frequency (%) | |
| 110628 | 1 | < 0.1% | |
| 98751 | 1 | < 0.1% | |
| 97107 | 1 | < 0.1% | |
| 90075 | 1 | < 0.1% | |
| 83919 | 1 | < 0.1% | |
| 70284 | 1 | < 0.1% | |
| 68268 | 1 | < 0.1% | |
| 67993 | 1 | < 0.1% | |
| 66159 | 1 | < 0.1% | |
| 66087 | 1 | < 0.1% |
| Distinct | 186 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 764.6577861 |
|---|---|
| Minimum | 0 |
| Maximum | 60337000 |
| Zeros | 128767 |
| Zeros (%) | 18.1% |
| Memory size | 5.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 10 |
| Q3 | 152 |
| 95-th percentile | 152 |
| Maximum | 60337000 |
| Range | 60337000 |
| Interquartile range (IQR) | 151 |
Descriptive statistics
| Standard deviation | 109348.7182 |
|---|---|
| Coefficient of variation (CV) | 143.0034719 |
| Kurtosis | 176709.7195 |
| Mean | 764.6577861 |
| Median Absolute Deviation (MAD) | 9 |
| Skewness | 387.4378225 |
| Sum | 543548576 |
| Variance | 1.195714217e+10 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 10 | 314733 | 44.3% | |
| 152 | 163506 | 23.0% | |
| 0 | 128767 | 18.1% | |
| 1 | 71334 | 10.0% | |
| 1000 | 9280 | 1.3% | |
| 2000 | 6211 | 0.9% | |
| 3000 | 4275 | 0.6% | |
| 4000 | 3016 | 0.4% | |
| 5000 | 2063 | 0.3% | |
| 6000 | 1613 | 0.2% | |
| 7000 | 1201 | 0.2% | |
| 8000 | 896 | 0.1% | |
| 9000 | 698 | 0.1% | |
| 10000 | 536 | 0.1% | |
| 11000 | 439 | 0.1% | |
| 12000 | 315 | < 0.1% | |
| 13000 | 281 | < 0.1% | |
| 14000 | 230 | < 0.1% | |
| 15000 | 192 | < 0.1% | |
| 17000 | 134 | < 0.1% | |
| 16000 | 130 | < 0.1% | |
| 18000 | 104 | < 0.1% | |
| 19000 | 97 | < 0.1% | |
| 20000 | 70 | < 0.1% | |
| 21000 | 63 | < 0.1% | |
| Other values (161) | 655 | 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 128767 | 18.1% | |
| 1 | 71334 | 10.0% | |
| 10 | 314733 | 44.3% | |
| 152 | 163506 | 23.0% | |
| 1000 | 9280 | 1.3% | |
| 2000 | 6211 | 0.9% | |
| 3000 | 4275 | 0.6% | |
| 4000 | 3016 | 0.4% | |
| 5000 | 2063 | 0.3% | |
| 6000 | 1613 | 0.2% |
| Value | Count | Frequency (%) | |
| 60337000 | 1 | < 0.1% | |
| 42894000 | 1 | < 0.1% | |
| 23615000 | 1 | < 0.1% | |
| 22187000 | 1 | < 0.1% | |
| 21383000 | 1 | < 0.1% | |
| 21369000 | 1 | < 0.1% | |
| 21367000 | 1 | < 0.1% | |
| 19060000 | 1 | < 0.1% | |
| 9818000 | 1 | < 0.1% | |
| 4582000 | 1 | < 0.1% |
| Distinct | 245 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 328202 |
| Missing (%) | 46.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.703152808e+10 |
|---|---|
| Minimum | 1.70311503e+10 |
| Maximum | 1.70318435e+10 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 5.4 MiB |
Quantile statistics
| Minimum | 1.70311503e+10 |
|---|---|
| 5-th percentile | 1.70312205e+10 |
| Q1 | 1.70312414e+10 |
| median | 1.70312832e+10 |
| Q3 | 1.7031833e+10 |
| 95-th percentile | 1.70318419e+10 |
| Maximum | 1.70318435e+10 |
| Range | 693200 |
| Interquartile range (IQR) | 591600 |
Descriptive statistics
| Standard deviation | 298440.1362 |
|---|---|
| Coefficient of variation (CV) | 1.752280446e-05 |
| Kurtosis | -1.987032312 |
| Mean | 1.703152808e+10 |
| Median Absolute Deviation (MAD) | 92499 |
| Skewness | 0.04601466778 |
| Sum | 6.51689281e+15 |
| Variance | 8.90665149e+10 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 1.7031833e+10 | 95513 | 13.4% | |
| 1.70312414e+10 | 31126 | 4.4% | |
| 1.70318331e+10 | 28678 | 4.0% | |
| 1.70312435e+10 | 16177 | 2.3% | |
| 1.70318419e+10 | 15498 | 2.2% | |
| 1.70312415e+10 | 11360 | 1.6% | |
| 1.70312416e+10 | 7160 | 1.0% | |
| 1.70318423e+10 | 7071 | 1.0% | |
| 1.70312421e+10 | 7051 | 1.0% | |
| 1.70312405e+10 | 6820 | 1.0% | |
| 1.7031831e+10 | 6678 | 0.9% | |
| 1.70312206e+10 | 6488 | 0.9% | |
| 1.70318333e+10 | 6338 | 0.9% | |
| 1.70312422e+10 | 5693 | 0.8% | |
| 1.70312214e+10 | 5039 | 0.7% | |
| 1.70318323e+10 | 4949 | 0.7% | |
| 1.70312205e+10 | 4813 | 0.7% | |
| 1.70312222e+10 | 4377 | 0.6% | |
| 1.70312213e+10 | 4232 | 0.6% | |
| 1.70312434e+10 | 3863 | 0.5% | |
| 1.70312423e+10 | 3797 | 0.5% | |
| 1.7031242e+10 | 3755 | 0.5% | |
| 1.70312433e+10 | 3126 | 0.4% | |
| 1.70312403e+10 | 3079 | 0.4% | |
| 1.70312801e+10 | 2712 | 0.4% | |
| Other values (220) | 87244 | 12.3% | |
| (Missing) | 328202 | 46.2% |
| Value | Count | Frequency (%) | |
| 1.70311503e+10 | 2 | < 0.1% | |
| 1.70311504e+10 | 9 | < 0.1% | |
| 1.70311505e+10 | 2 | < 0.1% | |
| 1.70311506e+10 | 47 | < 0.1% | |
| 1.70311507e+10 | 88 | < 0.1% | |
| 1.70311508e+10 | 137 | < 0.1% | |
| 1.7031151e+10 | 40 | < 0.1% | |
| 1.7031151e+10 | 313 | < 0.1% | |
| 1.70311511e+10 | 138 | < 0.1% | |
| 1.70311512e+10 | 117 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1.70318435e+10 | 56 | < 0.1% | |
| 1.70318434e+10 | 15 | < 0.1% | |
| 1.70318433e+10 | 112 | < 0.1% | |
| 1.70318432e+10 | 88 | < 0.1% | |
| 1.70318431e+10 | 217 | < 0.1% | |
| 1.7031843e+10 | 175 | < 0.1% | |
| 1.70318429e+10 | 513 | 0.1% | |
| 1.70318423e+10 | 7071 | 1.0% | |
| 1.70318422e+10 | 17 | < 0.1% | |
| 1.70318421e+10 | 93 | < 0.1% |
| Distinct | 253 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 328364 |
| Missing (%) | 46.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.703151696e+10 |
|---|---|
| Minimum | 1.70310514e+10 |
| Maximum | 1.70318437e+10 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 5.4 MiB |
Quantile statistics
| Minimum | 1.70310514e+10 |
|---|---|
| 5-th percentile | 1.70312205e+10 |
| Q1 | 1.70312414e+10 |
| median | 1.70312804e+10 |
| Q3 | 1.7031833e+10 |
| 95-th percentile | 1.70318419e+10 |
| Maximum | 1.70318437e+10 |
| Range | 792300 |
| Interquartile range (IQR) | 591600 |
Descriptive statistics
| Standard deviation | 297727.953 |
|---|---|
| Coefficient of variation (CV) | 1.74810003e-05 |
| Kurtosis | -1.972601007 |
| Mean | 1.703151696e+10 |
| Median Absolute Deviation (MAD) | 69898 |
| Skewness | 0.1230200025 |
| Sum | 6.514129449e+15 |
| Variance | 8.864193401e+10 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 1.7031833e+10 | 80590 | 11.3% | |
| 1.70318331e+10 | 29175 | 4.1% | |
| 1.70312414e+10 | 24362 | 3.4% | |
| 1.70312435e+10 | 17485 | 2.5% | |
| 1.70318419e+10 | 15388 | 2.2% | |
| 1.70312415e+10 | 11220 | 1.6% | |
| 1.70318423e+10 | 9388 | 1.3% | |
| 1.70312421e+10 | 7187 | 1.0% | |
| 1.70312422e+10 | 6530 | 0.9% | |
| 1.70318323e+10 | 6376 | 0.9% | |
| 1.70318333e+10 | 6369 | 0.9% | |
| 1.7031831e+10 | 6139 | 0.9% | |
| 1.70312405e+10 | 5898 | 0.8% | |
| 1.70312416e+10 | 5155 | 0.7% | |
| 1.70312214e+10 | 4782 | 0.7% | |
| 1.70312423e+10 | 4722 | 0.7% | |
| 1.70312434e+10 | 4687 | 0.7% | |
| 1.7031242e+10 | 4666 | 0.7% | |
| 1.70312206e+10 | 4259 | 0.6% | |
| 1.70312213e+10 | 4257 | 0.6% | |
| 1.70312205e+10 | 4220 | 0.6% | |
| 1.70312801e+10 | 4126 | 0.6% | |
| 1.70312222e+10 | 3748 | 0.5% | |
| 1.70312433e+10 | 3713 | 0.5% | |
| 1.70312403e+10 | 3540 | 0.5% | |
| Other values (228) | 104493 | 14.7% | |
| (Missing) | 328364 | 46.2% |
| Value | Count | Frequency (%) | |
| 1.70310514e+10 | 3 | < 0.1% | |
| 1.70310707e+10 | 24 | < 0.1% | |
| 1.70310715e+10 | 3 | < 0.1% | |
| 1.70311502e+10 | 6 | < 0.1% | |
| 1.70311503e+10 | 7 | < 0.1% | |
| 1.70311504e+10 | 8 | < 0.1% | |
| 1.70311506e+10 | 73 | < 0.1% | |
| 1.70311507e+10 | 89 | < 0.1% | |
| 1.70311508e+10 | 189 | < 0.1% | |
| 1.7031151e+10 | 64 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1.70318437e+10 | 36 | < 0.1% | |
| 1.70318435e+10 | 73 | < 0.1% | |
| 1.70318434e+10 | 13 | < 0.1% | |
| 1.70318433e+10 | 211 | < 0.1% | |
| 1.70318432e+10 | 199 | < 0.1% | |
| 1.70318431e+10 | 334 | < 0.1% | |
| 1.7031843e+10 | 152 | < 0.1% | |
| 1.70318429e+10 | 772 | 0.1% | |
| 1.70318423e+10 | 9388 | 1.3% | |
| 1.70318422e+10 | 215 | < 0.1% |
| Distinct | 30 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 97389 |
| Missing (%) | 13.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 24.74810498 |
|---|---|
| Minimum | 3 |
| Maximum | 76 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 5.4 MiB |
Quantile statistics
| Minimum | 3 |
|---|---|
| 5-th percentile | 19 |
| Q1 | 22 |
| median | 24 |
| Q3 | 28 |
| 95-th percentile | 28 |
| Maximum | 76 |
| Range | 73 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.281728374 |
|---|---|
| Coefficient of variation (CV) | 0.1326052389 |
| Kurtosis | 1.363218258 |
| Mean | 24.74810498 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | -0.4330516038 |
| Sum | 15181725 |
| Variance | 10.76974112 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=30)
| Value | Count | Frequency (%) | |
| 28 | 193878 | 27.3% | |
| 24 | 186277 | 26.2% | |
| 22 | 90728 | 12.8% | |
| 19 | 20563 | 2.9% | |
| 25 | 19277 | 2.7% | |
| 21 | 17503 | 2.5% | |
| 23 | 11906 | 1.7% | |
| 31 | 11721 | 1.6% | |
| 20 | 11469 | 1.6% | |
| 29 | 10251 | 1.4% | |
| 30 | 8080 | 1.1% | |
| 16 | 7992 | 1.1% | |
| 27 | 7467 | 1.1% | |
| 15 | 7082 | 1.0% | |
| 26 | 5073 | 0.7% | |
| 18 | 2067 | 0.3% | |
| 17 | 1766 | 0.2% | |
| 8 | 141 | < 0.1% | |
| 7 | 123 | < 0.1% | |
| 60 | 38 | < 0.1% | |
| 5 | 30 | < 0.1% | |
| 42 | 5 | < 0.1% | |
| 32 | 4 | < 0.1% | |
| 61 | 3 | < 0.1% | |
| 63 | 1 | < 0.1% | |
| Other values (5) | 5 | < 0.1% | |
| (Missing) | 97389 | 13.7% |
| Value | Count | Frequency (%) | |
| 3 | 1 | < 0.1% | |
| 5 | 30 | < 0.1% | |
| 7 | 123 | < 0.1% | |
| 8 | 141 | < 0.1% | |
| 15 | 7082 | 1.0% | |
| 16 | 7992 | 1.1% | |
| 17 | 1766 | 0.2% | |
| 18 | 2067 | 0.3% | |
| 19 | 20563 | 2.9% | |
| 20 | 11469 | 1.6% |
| Value | Count | Frequency (%) | |
| 76 | 1 | < 0.1% | |
| 63 | 1 | < 0.1% | |
| 61 | 3 | < 0.1% | |
| 60 | 38 | < 0.1% | |
| 58 | 1 | < 0.1% | |
| 42 | 5 | < 0.1% | |
| 34 | 1 | < 0.1% | |
| 33 | 1 | < 0.1% | |
| 32 | 4 | < 0.1% | |
| 31 | 11721 | 1.6% |
| Distinct | 40 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 97916 |
| Missing (%) | 13.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 24.59813223 |
|---|---|
| Minimum | 2 |
| Maximum | 67 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 5.4 MiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 19 |
| Q1 | 22 |
| median | 24 |
| Q3 | 28 |
| 95-th percentile | 29 |
| Maximum | 67 |
| Range | 65 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.530747418 |
|---|---|
| Coefficient of variation (CV) | 0.143537216 |
| Kurtosis | 5.316649625 |
| Mean | 24.59813223 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | -0.5075234357 |
| Sum | 15076761 |
| Variance | 12.46617733 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=40)
| Value | Count | Frequency (%) | |
| 24 | 188272 | 26.5% | |
| 28 | 181823 | 25.6% | |
| 22 | 92579 | 13.0% | |
| 19 | 20368 | 2.9% | |
| 21 | 18722 | 2.6% | |
| 25 | 18305 | 2.6% | |
| 23 | 15686 | 2.2% | |
| 31 | 13347 | 1.9% | |
| 20 | 9774 | 1.4% | |
| 29 | 9551 | 1.3% | |
| 16 | 8998 | 1.3% | |
| 30 | 8941 | 1.3% | |
| 15 | 7479 | 1.1% | |
| 27 | 6742 | 0.9% | |
| 26 | 4859 | 0.7% | |
| 17 | 2352 | 0.3% | |
| 18 | 2137 | 0.3% | |
| 7 | 1154 | 0.2% | |
| 8 | 1035 | 0.1% | |
| 5 | 448 | 0.1% | |
| 60 | 160 | < 0.1% | |
| 32 | 71 | < 0.1% | |
| 6 | 21 | < 0.1% | |
| 59 | 18 | < 0.1% | |
| 14 | 16 | < 0.1% | |
| Other values (15) | 65 | < 0.1% | |
| (Missing) | 97916 | 13.8% |
| Value | Count | Frequency (%) | |
| 2 | 1 | < 0.1% | |
| 3 | 4 | < 0.1% | |
| 4 | 2 | < 0.1% | |
| 5 | 448 | 0.1% | |
| 6 | 21 | < 0.1% | |
| 7 | 1154 | 0.2% | |
| 8 | 1035 | 0.1% | |
| 10 | 1 | < 0.1% | |
| 11 | 4 | < 0.1% | |
| 14 | 16 | < 0.1% |
| Value | Count | Frequency (%) | |
| 67 | 1 | < 0.1% | |
| 66 | 3 | < 0.1% | |
| 61 | 1 | < 0.1% | |
| 60 | 160 | < 0.1% | |
| 59 | 18 | < 0.1% | |
| 58 | 13 | < 0.1% | |
| 57 | 7 | < 0.1% | |
| 56 | 3 | < 0.1% | |
| 42 | 3 | < 0.1% | |
| 39 | 2 | < 0.1% |
| Distinct | 30 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 97389 |
| Missing (%) | 13.7% |
| Memory size | 5.4 MiB |
| NEAR WEST SIDE | |
|---|---|
| WEST TOWN | |
| LOGAN SQUARE | |
| BELMONT CRAGIN | |
| AUSTIN | 19277 |
| Other values (25) |
| Value | Count | Frequency (%) | |
| NEAR WEST SIDE | 193878 | 27.3% | |
| WEST TOWN | 186277 | 26.2% | |
| LOGAN SQUARE | 90728 | 12.8% | |
| BELMONT CRAGIN | 20563 | 2.9% | |
| AUSTIN | 19277 | 2.7% | |
| AVONDALE | 17503 | 2.5% | |
| HUMBOLDT PARK | 11906 | 1.7% | |
| LOWER WEST SIDE | 11721 | 1.6% | |
| HERMOSA | 11469 | 1.6% | |
| NORTH LAWNDALE | 10251 | 1.4% | |
| SOUTH LAWNDALE | 8080 | 1.1% | |
| IRVING PARK | 7992 | 1.1% | |
| EAST GARFIELD PARK | 7467 | 1.1% | |
| PORTAGE PARK | 7082 | 1.0% | |
| WEST GARFIELD PARK | 5073 | 0.7% | |
| MONTCLARE | 2067 | 0.3% | |
| DUNNING | 1766 | 0.2% | |
| NEAR NORTH SIDE | 141 | < 0.1% | |
| LINCOLN PARK | 123 | < 0.1% | |
| BRIDGEPORT | 38 | < 0.1% | |
| NORTH CENTER | 30 | < 0.1% | |
| WOODLAWN | 5 | < 0.1% | |
| LOOP | 4 | < 0.1% | |
| NEW CITY | 3 | < 0.1% | |
| NEAR SOUTH SIDE | 1 | < 0.1% | |
| Other values (5) | 5 | < 0.1% | |
| (Missing) | 97389 | 13.7% |
Frequencies of value counts
Unique
| Unique | 6 ? |
|---|---|
| Unique (%) | < 0.1% |
Histogram of lengths of the category
Length
| Max length | 18 |
|---|---|
| Median length | 12 |
| Mean length | 10.43389431 |
| Min length | 3 |
Most occurring characters
| Value | Count | Frequency (%) | |
| E | 996285 | 13.4% | |
| 779600 | 10.5% | ||
| S | 739713 | 10.0% | |
| T | 670164 | 9.0% | |
| W | 613292 | 8.3% | |
| N | 593327 | 8.0% | |
| A | 567263 | 7.6% | |
| R | 408360 | 5.5% | |
| O | 378002 | 5.1% | |
| I | 276036 | 3.7% | |
| D | 267830 | 3.6% | |
| L | 203945 | 2.7% | |
| n | 194778 | 2.6% | |
| G | 140712 | 1.9% | |
| U | 131761 | 1.8% | |
| a | 97389 | 1.3% | |
| Q | 90729 | 1.2% | |
| P | 46770 | 0.6% | |
| M | 46006 | 0.6% | |
| H | 41880 | 0.6% | |
| K | 39645 | 0.5% | |
| B | 32508 | 0.4% | |
| V | 25495 | 0.3% | |
| C | 22786 | 0.3% | |
| F | 12540 | 0.2% |
Most occurring categories
| Value | Count | Frequency (%) | |
| Uppercase Letter | 6345052 | 85.5% | |
| Space Separator | 779600 | 10.5% | |
| Lowercase Letter | 292167 | 3.9% |
Most frequent Lowercase Letter characters
| Value | Count | Frequency (%) | |
| n | 194778 | 66.7% | |
| a | 97389 | 33.3% |
Most frequent Uppercase Letter characters
| Value | Count | Frequency (%) | |
| E | 996285 | 15.7% | |
| S | 739713 | 11.7% | |
| T | 670164 | 10.6% | |
| W | 613292 | 9.7% | |
| N | 593327 | 9.4% | |
| A | 567263 | 8.9% | |
| R | 408360 | 6.4% | |
| O | 378002 | 6.0% | |
| I | 276036 | 4.4% | |
| D | 267830 | 4.2% | |
| L | 203945 | 3.2% | |
| G | 140712 | 2.2% | |
| U | 131761 | 2.1% | |
| Q | 90729 | 1.4% | |
| P | 46770 | 0.7% | |
| M | 46006 | 0.7% | |
| H | 41880 | 0.7% | |
| K | 39645 | 0.6% | |
| B | 32508 | 0.5% | |
| V | 25495 | 0.4% | |
| C | 22786 | 0.4% | |
| F | 12540 | 0.2% | |
| Y | 3 | < 0.1% |
Most frequent Space Separator characters
| Value | Count | Frequency (%) | |
| 779600 | 100.0% |
Most occurring scripts
| Value | Count | Frequency (%) | |
| Latin | 6637219 | 89.5% | |
| Common | 779600 | 10.5% |
Most frequent Latin characters
| Value | Count | Frequency (%) | |
| E | 996285 | 15.0% | |
| S | 739713 | 11.1% | |
| T | 670164 | 10.1% | |
| W | 613292 | 9.2% | |
| N | 593327 | 8.9% | |
| A | 567263 | 8.5% | |
| R | 408360 | 6.2% | |
| O | 378002 | 5.7% | |
| I | 276036 | 4.2% | |
| D | 267830 | 4.0% | |
| L | 203945 | 3.1% | |
| n | 194778 | 2.9% | |
| G | 140712 | 2.1% | |
| U | 131761 | 2.0% | |
| a | 97389 | 1.5% | |
| Q | 90729 | 1.4% | |
| P | 46770 | 0.7% | |
| M | 46006 | 0.7% | |
| H | 41880 | 0.6% | |
| K | 39645 | 0.6% | |
| B | 32508 | 0.5% | |
| V | 25495 | 0.4% | |
| C | 22786 | 0.3% | |
| F | 12540 | 0.2% | |
| Y | 3 | < 0.1% |
Most frequent Common characters
| Value | Count | Frequency (%) | |
| 779600 | 100.0% |
Most occurring blocks
| Value | Count | Frequency (%) | |
| ASCII | 7416819 | 100.0% |
Most frequent ASCII characters
| Value | Count | Frequency (%) | |
| E | 996285 | 13.4% | |
| 779600 | 10.5% | ||
| S | 739713 | 10.0% | |
| T | 670164 | 9.0% | |
| W | 613292 | 8.3% | |
| N | 593327 | 8.0% | |
| A | 567263 | 7.6% | |
| R | 408360 | 5.5% | |
| O | 378002 | 5.1% | |
| I | 276036 | 3.7% | |
| D | 267830 | 3.6% | |
| L | 203945 | 2.7% | |
| n | 194778 | 2.6% | |
| G | 140712 | 1.9% | |
| U | 131761 | 1.8% | |
| a | 97389 | 1.3% | |
| Q | 90729 | 1.2% | |
| P | 46770 | 0.6% | |
| M | 46006 | 0.6% | |
| H | 41880 | 0.6% | |
| K | 39645 | 0.5% | |
| B | 32508 | 0.4% | |
| V | 25495 | 0.3% | |
| C | 22786 | 0.3% | |
| F | 12540 | 0.2% |
| Distinct | 40 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 97916 |
| Missing (%) | 13.8% |
| Memory size | 5.4 MiB |
| WEST TOWN | |
|---|---|
| NEAR WEST SIDE | |
| LOGAN SQUARE | |
| BELMONT CRAGIN | |
| AVONDALE | 18722 |
| Other values (35) |
| Value | Count | Frequency (%) | |
| WEST TOWN | 188272 | 26.5% | |
| NEAR WEST SIDE | 181823 | 25.6% | |
| LOGAN SQUARE | 92579 | 13.0% | |
| BELMONT CRAGIN | 20368 | 2.9% | |
| AVONDALE | 18722 | 2.6% | |
| AUSTIN | 18305 | 2.6% | |
| HUMBOLDT PARK | 15686 | 2.2% | |
| LOWER WEST SIDE | 13347 | 1.9% | |
| HERMOSA | 9774 | 1.4% | |
| NORTH LAWNDALE | 9551 | 1.3% | |
| IRVING PARK | 8998 | 1.3% | |
| SOUTH LAWNDALE | 8941 | 1.3% | |
| PORTAGE PARK | 7479 | 1.1% | |
| EAST GARFIELD PARK | 6742 | 0.9% | |
| WEST GARFIELD PARK | 4859 | 0.7% | |
| DUNNING | 2352 | 0.3% | |
| MONTCLARE | 2137 | 0.3% | |
| LINCOLN PARK | 1154 | 0.2% | |
| NEAR NORTH SIDE | 1035 | 0.1% | |
| NORTH CENTER | 448 | 0.1% | |
| BRIDGEPORT | 160 | < 0.1% | |
| LOOP | 71 | < 0.1% | |
| LAKE VIEW | 21 | < 0.1% | |
| MCKINLEY PARK | 18 | < 0.1% | |
| ALBANY PARK | 16 | < 0.1% | |
| Other values (15) | 65 | < 0.1% | |
| (Missing) | 97916 | 13.8% |
Frequencies of value counts
Unique
| Unique | 4 ? |
|---|---|
| Unique (%) | < 0.1% |
Histogram of lengths of the category
Length
| Max length | 18 |
|---|---|
| Median length | 12 |
| Mean length | 10.39918322 |
| Min length | 3 |
Most occurring characters
| Value | Count | Frequency (%) | |
| E | 969791 | 13.1% | |
| 769211 | 10.4% | ||
| S | 720894 | 9.8% | |
| T | 667912 | 9.0% | |
| W | 608453 | 8.2% | |
| N | 592027 | 8.0% | |
| A | 563922 | 7.6% | |
| R | 405990 | 5.5% | |
| O | 389856 | 5.3% | |
| I | 268225 | 3.6% | |
| D | 263244 | 3.6% | |
| L | 213872 | 2.9% | |
| n | 195832 | 2.6% | |
| G | 143568 | 1.9% | |
| U | 137897 | 1.9% | |
| a | 97916 | 1.3% | |
| Q | 92589 | 1.3% | |
| P | 52684 | 0.7% | |
| M | 47991 | 0.6% | |
| H | 45484 | 0.6% | |
| K | 45011 | 0.6% | |
| B | 36243 | 0.5% | |
| V | 27741 | 0.4% | |
| C | 24141 | 0.3% | |
| F | 11612 | 0.2% | |
| Other values (2) | 39 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) | |
| Uppercase Letter | 6329186 | 85.6% | |
| Space Separator | 769211 | 10.4% | |
| Lowercase Letter | 293748 | 4.0% |
Most frequent Lowercase Letter characters
| Value | Count | Frequency (%) | |
| n | 195832 | 66.7% | |
| a | 97916 | 33.3% |
Most frequent Uppercase Letter characters
| Value | Count | Frequency (%) | |
| E | 969791 | 15.3% | |
| S | 720894 | 11.4% | |
| T | 667912 | 10.6% | |
| W | 608453 | 9.6% | |
| N | 592027 | 9.4% | |
| A | 563922 | 8.9% | |
| R | 405990 | 6.4% | |
| O | 389856 | 6.2% | |
| I | 268225 | 4.2% | |
| D | 263244 | 4.2% | |
| L | 213872 | 3.4% | |
| G | 143568 | 2.3% | |
| U | 137897 | 2.2% | |
| Q | 92589 | 1.5% | |
| P | 52684 | 0.8% | |
| M | 47991 | 0.8% | |
| H | 45484 | 0.7% | |
| K | 45011 | 0.7% | |
| B | 36243 | 0.6% | |
| V | 27741 | 0.4% | |
| C | 24141 | 0.4% | |
| F | 11612 | 0.2% | |
| Y | 35 | < 0.1% | |
| J | 4 | < 0.1% |
Most frequent Space Separator characters
| Value | Count | Frequency (%) | |
| 769211 | 100.0% |
Most occurring scripts
| Value | Count | Frequency (%) | |
| Latin | 6622934 | 89.6% | |
| Common | 769211 | 10.4% |
Most frequent Latin characters
| Value | Count | Frequency (%) | |
| E | 969791 | 14.6% | |
| S | 720894 | 10.9% | |
| T | 667912 | 10.1% | |
| W | 608453 | 9.2% | |
| N | 592027 | 8.9% | |
| A | 563922 | 8.5% | |
| R | 405990 | 6.1% | |
| O | 389856 | 5.9% | |
| I | 268225 | 4.0% | |
| D | 263244 | 4.0% | |
| L | 213872 | 3.2% | |
| n | 195832 | 3.0% | |
| G | 143568 | 2.2% | |
| U | 137897 | 2.1% | |
| a | 97916 | 1.5% | |
| Q | 92589 | 1.4% | |
| P | 52684 | 0.8% | |
| M | 47991 | 0.7% | |
| H | 45484 | 0.7% | |
| K | 45011 | 0.7% | |
| B | 36243 | 0.5% | |
| V | 27741 | 0.4% | |
| C | 24141 | 0.4% | |
| F | 11612 | 0.2% | |
| Y | 35 | < 0.1% |
Most frequent Common characters
| Value | Count | Frequency (%) | |
| 769211 | 100.0% |
Most occurring blocks
| Value | Count | Frequency (%) | |
| ASCII | 7392145 | 100.0% |
Most frequent ASCII characters
| Value | Count | Frequency (%) | |
| E | 969791 | 13.1% | |
| 769211 | 10.4% | ||
| S | 720894 | 9.8% | |
| T | 667912 | 9.0% | |
| W | 608453 | 8.2% | |
| N | 592027 | 8.0% | |
| A | 563922 | 7.6% | |
| R | 405990 | 5.5% | |
| O | 389856 | 5.3% | |
| I | 268225 | 3.6% | |
| D | 263244 | 3.6% | |
| L | 213872 | 2.9% | |
| n | 195832 | 2.6% | |
| G | 143568 | 1.9% | |
| U | 137897 | 1.9% | |
| a | 97916 | 1.3% | |
| Q | 92589 | 1.3% | |
| P | 52684 | 0.7% | |
| M | 47991 | 0.6% | |
| H | 45484 | 0.6% | |
| K | 45011 | 0.6% | |
| B | 36243 | 0.5% | |
| V | 27741 | 0.4% | |
| C | 24141 | 0.3% | |
| F | 11612 | 0.2% | |
| Other values (2) | 39 | < 0.1% |
| Distinct | 275 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 97388 |
| Missing (%) | 13.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 41.89878483 |
|---|---|
| Minimum | 41.77887641 |
| Maximum | 41.97555516 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 5.4 MiB |
Quantile statistics
| Minimum | 41.77887641 |
|---|---|
| 5-th percentile | 41.86789231 |
| Q1 | 41.88528825 |
| median | 41.89973715 |
| Q3 | 41.91590954 |
| 95-th percentile | 41.93763562 |
| Maximum | 41.97555516 |
| Range | 0.1966787448 |
| Interquartile range (IQR) | 0.03062129245 |
Descriptive statistics
| Standard deviation | 0.02265581917 |
|---|---|
| Coefficient of variation (CV) | 0.0005407273568 |
| Kurtosis | -0.1019063439 |
| Mean | 41.89878483 |
| Median Absolute Deviation (MAD) | 0.01444890182 |
| Skewness | 0.06787593783 |
| Sum | 25702851.45 |
| Variance | 0.0005132861424 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 41.88528825 | 95513 | 13.4% | |
| 41.90120673 | 49254 | 6.9% | |
| 41.92275986 | 39616 | 5.6% | |
| 41.90602339 | 31126 | 4.4% | |
| 41.87400538 | 30920 | 4.3% | |
| 41.87907673 | 28678 | 4.0% | |
| 41.8941013 | 16507 | 2.3% | |
| 41.89265362 | 16177 | 2.3% | |
| 41.92726074 | 15951 | 2.2% | |
| 41.86789231 | 15498 | 2.2% | |
| 41.93866589 | 12001 | 1.7% | |
| 41.90837594 | 11360 | 1.6% | |
| 41.90006985 | 9868 | 1.4% | |
| 41.86018959 | 8704 | 1.2% | |
| 41.85026617 | 8091 | 1.1% | |
| 41.92434776 | 7892 | 1.1% | |
| 41.90670971 | 7160 | 1.0% | |
| 41.90220092 | 7071 | 1.0% | |
| 41.8996699 | 7051 | 1.0% | |
| 41.91197004 | 6820 | 1.0% | |
| 41.83908701 | 6693 | 0.9% | |
| 41.91478774 | 6678 | 0.9% | |
| 41.92933118 | 6488 | 0.9% | |
| 41.87169145 | 6338 | 0.9% | |
| 41.95358182 | 6235 | 0.9% | |
| Other values (250) | 155761 | 21.9% | |
| (Missing) | 97388 | 13.7% |
| Value | Count | Frequency (%) | |
| 41.77887641 | 5 | < 0.1% | |
| 41.79543063 | 1 | < 0.1% | |
| 41.80901852 | 3 | < 0.1% | |
| 41.8173668 | 1 | < 0.1% | |
| 41.83006543 | 326 | < 0.1% | |
| 41.83615066 | 31 | < 0.1% | |
| 41.83821453 | 56 | < 0.1% | |
| 41.83880617 | 56 | < 0.1% | |
| 41.83908701 | 6693 | 0.9% | |
| 41.83954972 | 137 | < 0.1% |
| Value | Count | Frequency (%) | |
| 41.97555516 | 1 | < 0.1% | |
| 41.96581208 | 1 | < 0.1% | |
| 41.96051811 | 2 | < 0.1% | |
| 41.95879098 | 4 | < 0.1% | |
| 41.95736577 | 4 | < 0.1% | |
| 41.95679797 | 9 | < 0.1% | |
| 41.95677846 | 2 | < 0.1% | |
| 41.95609293 | 2 | < 0.1% | |
| 41.95585952 | 3 | < 0.1% | |
| 41.95402816 | 6034 | 0.8% |
| Distinct | 275 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 97388 |
| Missing (%) | 13.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -87.68519717 |
|---|---|
| Minimum | -87.89349472 |
| Maximum | -87.59492536 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 5.4 MiB |
Quantile statistics
| Minimum | -87.89349472 |
|---|---|
| 5-th percentile | -87.76311182 |
| Q1 | -87.69975406 |
| median | -87.67531026 |
| Q3 | -87.65724247 |
| 95-th percentile | -87.65251725 |
| Maximum | -87.59492536 |
| Range | 0.2985693607 |
| Interquartile range (IQR) | 0.04251159342 |
Descriptive statistics
| Standard deviation | 0.03318030117 |
|---|---|
| Coefficient of variation (CV) | -0.0003784025382 |
| Kurtosis | 0.9100195745 |
| Mean | -87.68519717 |
| Median Absolute Deviation (MAD) | 0.01806778913 |
| Skewness | -1.226284776 |
| Sum | -53790571.89 |
| Variance | 0.001100932386 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| -87.65724247 | 95513 | 13.4% | |
| -87.67635713 | 49254 | 6.9% | |
| -87.69915595 | 39616 | 5.6% | |
| -87.67531026 | 31126 | 4.4% | |
| -87.66351789 | 30920 | 4.3% | |
| -87.65704539 | 28678 | 4.0% | |
| -87.76311182 | 16507 | 2.3% | |
| -87.65251725 | 16177 | 2.3% | |
| -87.76550184 | 15951 | 2.2% | |
| -87.64296873 | 15498 | 2.2% | |
| -87.71121064 | 12001 | 1.7% | |
| -87.67093749 | 11360 | 1.6% | |
| -87.72091881 | 9868 | 1.4% | |
| -87.71721947 | 8704 | 1.2% | |
| -87.66756823 | 8091 | 1.1% | |
| -87.73474016 | 7892 | 1.1% | |
| -87.66532774 | 7160 | 1.0% | |
| -87.65606634 | 7071 | 1.0% | |
| -87.66983747 | 7051 | 1.0% | |
| -87.68363652 | 6820 | 1.0% | |
| -87.7140021 | 6693 | 0.9% | |
| -87.6769993 | 6678 | 0.9% | |
| -87.71198137 | 6488 | 0.9% | |
| -87.65412509 | 6338 | 0.9% | |
| -87.72345248 | 6235 | 0.9% | |
| Other values (250) | 155761 | 21.9% | |
| (Missing) | 97388 | 13.7% |
| Value | Count | Frequency (%) | |
| -87.89349472 | 1 | < 0.1% | |
| -87.82889594 | 3 | < 0.1% | |
| -87.80601984 | 1448 | 0.2% | |
| -87.7986731 | 119 | < 0.1% | |
| -87.79803232 | 1486 | 0.2% | |
| -87.79761488 | 461 | 0.1% | |
| -87.79682782 | 47 | < 0.1% | |
| -87.79679554 | 236 | < 0.1% | |
| -87.79652374 | 101 | < 0.1% | |
| -87.79481664 | 3 | < 0.1% |
| Value | Count | Frequency (%) | |
| -87.59492536 | 5 | < 0.1% | |
| -87.62033483 | 1 | < 0.1% | |
| -87.62519187 | 4 | < 0.1% | |
| -87.63330944 | 124 | < 0.1% | |
| -87.6339737 | 1 | < 0.1% | |
| -87.64262363 | 2128 | 0.3% | |
| -87.64280424 | 2712 | 0.4% | |
| -87.64296873 | 15498 | 2.2% | |
| -87.64420924 | 7 | < 0.1% | |
| -87.64878825 | 31 | < 0.1% |
| Distinct | 275 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 97388 |
| Missing (%) | 13.7% |
| Memory size | 5.4 MiB |
| POINT (-87.6572424682146 41.8852882458388) | |
|---|---|
| POINT (-87.6763571260391 41.9012067343156) | |
| POINT (-87.6991559457654 41.9227598585219) | |
| POINT (-87.6753102573397 41.9060233934322) | 31126 |
| POINT (-87.6635178867003 41.8740053848845) | 30920 |
| Other values (270) |
| Value | Count | Frequency (%) | |
| POINT (-87.6572424682146 41.8852882458388) | 95513 | 13.4% | |
| POINT (-87.6763571260391 41.9012067343156) | 49254 | 6.9% | |
| POINT (-87.6991559457654 41.9227598585219) | 39616 | 5.6% | |
| POINT (-87.6753102573397 41.9060233934322) | 31126 | 4.4% | |
| POINT (-87.6635178867003 41.8740053848845) | 30920 | 4.3% | |
| POINT (-87.65704538762 41.8790767308624) | 28678 | 4.0% | |
| POINT (-87.7631118242259 41.8941012961134) | 16507 | 2.3% | |
| POINT (-87.6525172461958 41.8926536169898) | 16177 | 2.3% | |
| POINT (-87.7655018368979 41.9272607415187) | 15951 | 2.2% | |
| POINT (-87.6429687254204 41.8678923093198) | 15498 | 2.2% | |
| POINT (-87.7112106378686 41.938665887698) | 12001 | 1.7% | |
| POINT (-87.670937488585 41.9083759393656) | 11360 | 1.6% | |
| POINT (-87.7209188101033 41.9000698450397) | 9868 | 1.4% | |
| POINT (-87.7172194738186 41.8601895923466) | 8704 | 1.2% | |
| POINT (-87.6675682255936 41.8502661710639) | 8091 | 1.1% | |
| POINT (-87.7347401601846 41.9243477570064) | 7892 | 1.1% | |
| POINT (-87.6653277387058 41.906709710732) | 7160 | 1.0% | |
| POINT (-87.656066340364 41.9022009180961) | 7071 | 1.0% | |
| POINT (-87.6698374693742 41.8996698963096) | 7051 | 1.0% | |
| POINT (-87.683636524973 41.91197004191531) | 6820 | 1.0% | |
| POINT (-87.7140020956845 41.8390870085266) | 6693 | 0.9% | |
| POINT (-87.6769992950319 41.9147877430097) | 6678 | 0.9% | |
| POINT (-87.71198136617541 41.9293311773652) | 6488 | 0.9% | |
| POINT (-87.6541250863618 41.8716914509744) | 6338 | 0.9% | |
| POINT (-87.7234524820666 41.95358181896) | 6235 | 0.9% | |
| Other values (250) | 155761 | 21.9% | |
| (Missing) | 97388 | 13.7% |
Frequencies of value counts
Unique
| Unique | 6 ? |
|---|---|
| Unique (%) | < 0.1% |
Histogram of lengths of the category
Length
| Max length | 45 |
|---|---|
| Median length | 42 |
| Mean length | 36.46716064 |
| Min length | 3 |
Most occurring characters
| Value | Count | Frequency (%) | |
| 8 | 2710235 | 10.5% | |
| 7 | 2170056 | 8.4% | |
| 6 | 2065817 | 8.0% | |
| 4 | 1976944 | 7.6% | |
| 1 | 1942527 | 7.5% | |
| 2 | 1647806 | 6.4% | |
| 5 | 1635497 | 6.3% | |
| 9 | 1565228 | 6.0% | |
| 3 | 1358435 | 5.2% | |
| 1226902 | 4.7% | ||
| . | 1226902 | 4.7% | |
| 0 | 1196159 | 4.6% | |
| P | 613451 | 2.4% | |
| O | 613451 | 2.4% | |
| I | 613451 | 2.4% | |
| N | 613451 | 2.4% | |
| T | 613451 | 2.4% | |
| ( | 613451 | 2.4% | |
| - | 613451 | 2.4% | |
| ) | 613451 | 2.4% | |
| n | 194776 | 0.8% | |
| a | 97388 | 0.4% |
Most occurring categories
| Value | Count | Frequency (%) | |
| Decimal Number | 18268704 | 70.5% | |
| Uppercase Letter | 3067255 | 11.8% | |
| Space Separator | 1226902 | 4.7% | |
| Other Punctuation | 1226902 | 4.7% | |
| Open Punctuation | 613451 | 2.4% | |
| Dash Punctuation | 613451 | 2.4% | |
| Close Punctuation | 613451 | 2.4% | |
| Lowercase Letter | 292164 | 1.1% |
Most frequent Lowercase Letter characters
| Value | Count | Frequency (%) | |
| n | 194776 | 66.7% | |
| a | 97388 | 33.3% |
Most frequent Uppercase Letter characters
| Value | Count | Frequency (%) | |
| P | 613451 | 20.0% | |
| O | 613451 | 20.0% | |
| I | 613451 | 20.0% | |
| N | 613451 | 20.0% | |
| T | 613451 | 20.0% |
Most frequent Space Separator characters
| Value | Count | Frequency (%) | |
| 1226902 | 100.0% |
Most frequent Open Punctuation characters
| Value | Count | Frequency (%) | |
| ( | 613451 | 100.0% |
Most frequent Dash Punctuation characters
| Value | Count | Frequency (%) | |
| - | 613451 | 100.0% |
Most frequent Decimal Number characters
| Value | Count | Frequency (%) | |
| 8 | 2710235 | 14.8% | |
| 7 | 2170056 | 11.9% | |
| 6 | 2065817 | 11.3% | |
| 4 | 1976944 | 10.8% | |
| 1 | 1942527 | 10.6% | |
| 2 | 1647806 | 9.0% | |
| 5 | 1635497 | 9.0% | |
| 9 | 1565228 | 8.6% | |
| 3 | 1358435 | 7.4% | |
| 0 | 1196159 | 6.5% |
Most frequent Other Punctuation characters
| Value | Count | Frequency (%) | |
| . | 1226902 | 100.0% |
Most frequent Close Punctuation characters
| Value | Count | Frequency (%) | |
| ) | 613451 | 100.0% |
Most occurring scripts
| Value | Count | Frequency (%) | |
| Common | 22562861 | 87.0% | |
| Latin | 3359419 | 13.0% |
Most frequent Latin characters
| Value | Count | Frequency (%) | |
| P | 613451 | 18.3% | |
| O | 613451 | 18.3% | |
| I | 613451 | 18.3% | |
| N | 613451 | 18.3% | |
| T | 613451 | 18.3% | |
| n | 194776 | 5.8% | |
| a | 97388 | 2.9% |
Most frequent Common characters
| Value | Count | Frequency (%) | |
| 8 | 2710235 | 12.0% | |
| 7 | 2170056 | 9.6% | |
| 6 | 2065817 | 9.2% | |
| 4 | 1976944 | 8.8% | |
| 1 | 1942527 | 8.6% | |
| 2 | 1647806 | 7.3% | |
| 5 | 1635497 | 7.2% | |
| 9 | 1565228 | 6.9% | |
| 3 | 1358435 | 6.0% | |
| 1226902 | 5.4% | ||
| . | 1226902 | 5.4% | |
| 0 | 1196159 | 5.3% | |
| ( | 613451 | 2.7% | |
| - | 613451 | 2.7% | |
| ) | 613451 | 2.7% |
Most occurring blocks
| Value | Count | Frequency (%) | |
| ASCII | 25922280 | 100.0% |
Most frequent ASCII characters
| Value | Count | Frequency (%) | |
| 8 | 2710235 | 10.5% | |
| 7 | 2170056 | 8.4% | |
| 6 | 2065817 | 8.0% | |
| 4 | 1976944 | 7.6% | |
| 1 | 1942527 | 7.5% | |
| 2 | 1647806 | 6.4% | |
| 5 | 1635497 | 6.3% | |
| 9 | 1565228 | 6.0% | |
| 3 | 1358435 | 5.2% | |
| 1226902 | 4.7% | ||
| . | 1226902 | 4.7% | |
| 0 | 1196159 | 4.6% | |
| P | 613451 | 2.4% | |
| O | 613451 | 2.4% | |
| I | 613451 | 2.4% | |
| N | 613451 | 2.4% | |
| T | 613451 | 2.4% | |
| ( | 613451 | 2.4% | |
| - | 613451 | 2.4% | |
| ) | 613451 | 2.4% | |
| n | 194776 | 0.8% | |
| a | 97388 | 0.4% |
| Distinct | 293 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 97916 |
| Missing (%) | 13.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 41.89905047 |
|---|---|
| Minimum | 41.77184916 |
| Maximum | 42.00157215 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 5.4 MiB |
Quantile statistics
| Minimum | 41.77184916 |
|---|---|
| 5-th percentile | 41.86018959 |
| Q1 | 41.88528825 |
| median | 41.89973715 |
| Q3 | 41.91920702 |
| 95-th percentile | 41.93866589 |
| Maximum | 42.00157215 |
| Range | 0.2297229873 |
| Interquartile range (IQR) | 0.03391877183 |
Descriptive statistics
| Standard deviation | 0.0230969406 |
|---|---|
| Coefficient of variation (CV) | 0.0005512521249 |
| Kurtosis | -0.07910840333 |
| Mean | 41.89905047 |
| Median Absolute Deviation (MAD) | 0.01498704298 |
| Skewness | 0.03523701861 |
| Sum | 25680891.71 |
| Variance | 0.0005334686653 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 41.88528825 | 80590 | 11.3% | |
| 41.90120673 | 46754 | 6.6% | |
| 41.92275986 | 38199 | 5.4% | |
| 41.87907673 | 29175 | 4.1% | |
| 41.87400538 | 28918 | 4.1% | |
| 41.90602339 | 24362 | 3.4% | |
| 41.89265362 | 17485 | 2.5% | |
| 41.8941013 | 15800 | 2.2% | |
| 41.92726074 | 15722 | 2.2% | |
| 41.86789231 | 15388 | 2.2% | |
| 41.90006985 | 12523 | 1.8% | |
| 41.93866589 | 12298 | 1.7% | |
| 41.90837594 | 11220 | 1.6% | |
| 41.90220092 | 9388 | 1.3% | |
| 41.85026617 | 9047 | 1.3% | |
| 41.86018959 | 7933 | 1.1% | |
| 41.83908701 | 7482 | 1.1% | |
| 41.8996699 | 7187 | 1.0% | |
| 41.95358182 | 7055 | 1.0% | |
| 41.92434776 | 6761 | 1.0% | |
| 41.89958937 | 6530 | 0.9% | |
| 41.95402816 | 6386 | 0.9% | |
| 41.91920702 | 6376 | 0.9% | |
| 41.87169145 | 6369 | 0.9% | |
| 41.91478774 | 6139 | 0.9% | |
| Other values (268) | 177836 | 25.0% | |
| (Missing) | 97916 | 13.8% |
| Value | Count | Frequency (%) | |
| 41.77184916 | 3 | < 0.1% | |
| 41.77593029 | 1 | < 0.1% | |
| 41.77887641 | 3 | < 0.1% | |
| 41.79618561 | 3 | < 0.1% | |
| 41.80891637 | 2 | < 0.1% | |
| 41.80901852 | 1 | < 0.1% | |
| 41.81087957 | 7 | < 0.1% | |
| 41.8173668 | 13 | < 0.1% | |
| 41.82992225 | 18 | < 0.1% | |
| 41.83006543 | 309 | < 0.1% |
| Value | Count | Frequency (%) | |
| 42.00157215 | 1 | < 0.1% | |
| 41.98501519 | 1 | < 0.1% | |
| 41.97882998 | 4 | < 0.1% | |
| 41.97517153 | 2 | < 0.1% | |
| 41.96806847 | 16 | < 0.1% | |
| 41.96581208 | 4 | < 0.1% | |
| 41.96067492 | 6 | < 0.1% | |
| 41.96051811 | 7 | < 0.1% | |
| 41.95879098 | 5 | < 0.1% | |
| 41.95736577 | 6 | < 0.1% |
| Distinct | 293 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 97916 |
| Missing (%) | 13.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -87.6855336 |
|---|---|
| Minimum | -87.82889594 |
| Maximum | -87.59492536 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 5.4 MiB |
Quantile statistics
| Minimum | -87.82889594 |
|---|---|
| 5-th percentile | -87.76311182 |
| Q1 | -87.69996837 |
| median | -87.67531026 |
| Q3 | -87.65724247 |
| 95-th percentile | -87.65251725 |
| Maximum | -87.59492536 |
| Range | 0.233970582 |
| Interquartile range (IQR) | 0.04272589707 |
Descriptive statistics
| Standard deviation | 0.03331799858 |
|---|---|
| Coefficient of variation (CV) | -0.0003799714413 |
| Kurtosis | 0.9422835867 |
| Mean | -87.6855336 |
| Median Absolute Deviation (MAD) | 0.01806778913 |
| Skewness | -1.207384391 |
| Sum | -53744480.31 |
| Variance | 0.001110089029 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| -87.65724247 | 80590 | 11.3% | |
| -87.67635713 | 46754 | 6.6% | |
| -87.69915595 | 38199 | 5.4% | |
| -87.65704539 | 29175 | 4.1% | |
| -87.66351789 | 28918 | 4.1% | |
| -87.67531026 | 24362 | 3.4% | |
| -87.65251725 | 17485 | 2.5% | |
| -87.76311182 | 15800 | 2.2% | |
| -87.76550184 | 15722 | 2.2% | |
| -87.64296873 | 15388 | 2.2% | |
| -87.72091881 | 12523 | 1.8% | |
| -87.71121064 | 12298 | 1.7% | |
| -87.67093749 | 11220 | 1.6% | |
| -87.65606634 | 9388 | 1.3% | |
| -87.66756823 | 9047 | 1.3% | |
| -87.71721947 | 7933 | 1.1% | |
| -87.7140021 | 7482 | 1.1% | |
| -87.66983747 | 7187 | 1.0% | |
| -87.72345248 | 7055 | 1.0% | |
| -87.73474016 | 6761 | 1.0% | |
| -87.67471877 | 6530 | 0.9% | |
| -87.76339991 | 6386 | 0.9% | |
| -87.67144903 | 6376 | 0.9% | |
| -87.65412509 | 6369 | 0.9% | |
| -87.6769993 | 6139 | 0.9% | |
| Other values (268) | 177836 | 25.0% | |
| (Missing) | 97916 | 13.8% |
| Value | Count | Frequency (%) | |
| -87.82889594 | 3 | < 0.1% | |
| -87.81160574 | 3 | < 0.1% | |
| -87.80601984 | 1984 | 0.3% | |
| -87.80453106 | 1 | < 0.1% | |
| -87.7986731 | 137 | < 0.1% | |
| -87.79803232 | 1549 | 0.2% | |
| -87.79761488 | 451 | 0.1% | |
| -87.79682782 | 64 | < 0.1% | |
| -87.79679554 | 166 | < 0.1% | |
| -87.79652374 | 103 | < 0.1% |
| Value | Count | Frequency (%) | |
| -87.59492536 | 3 | < 0.1% | |
| -87.59618358 | 2 | < 0.1% | |
| -87.62033483 | 12 | < 0.1% | |
| -87.62519187 | 70 | < 0.1% | |
| -87.62676275 | 3 | < 0.1% | |
| -87.63330944 | 809 | 0.1% | |
| -87.6339737 | 8 | < 0.1% | |
| -87.64262363 | 2563 | 0.4% | |
| -87.64280424 | 4126 | 0.6% | |
| -87.64296873 | 15388 | 2.2% |
| Distinct | 293 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 97916 |
| Missing (%) | 13.8% |
| Memory size | 5.4 MiB |
| POINT (-87.6572424682146 41.8852882458388) | |
|---|---|
| POINT (-87.6763571260391 41.9012067343156) | |
| POINT (-87.6991559457654 41.9227598585219) | 38199 |
| POINT (-87.65704538762 41.8790767308624) | 29175 |
| POINT (-87.6635178867003 41.8740053848845) | 28918 |
| Other values (288) |
| Value | Count | Frequency (%) | |
| POINT (-87.6572424682146 41.8852882458388) | 80590 | 11.3% | |
| POINT (-87.6763571260391 41.9012067343156) | 46754 | 6.6% | |
| POINT (-87.6991559457654 41.9227598585219) | 38199 | 5.4% | |
| POINT (-87.65704538762 41.8790767308624) | 29175 | 4.1% | |
| POINT (-87.6635178867003 41.8740053848845) | 28918 | 4.1% | |
| POINT (-87.6753102573397 41.9060233934322) | 24362 | 3.4% | |
| POINT (-87.6525172461958 41.8926536169898) | 17485 | 2.5% | |
| POINT (-87.7631118242259 41.8941012961134) | 15800 | 2.2% | |
| POINT (-87.7655018368979 41.9272607415187) | 15722 | 2.2% | |
| POINT (-87.6429687254204 41.8678923093198) | 15388 | 2.2% | |
| POINT (-87.7209188101033 41.9000698450397) | 12523 | 1.8% | |
| POINT (-87.7112106378686 41.938665887698) | 12298 | 1.7% | |
| POINT (-87.670937488585 41.9083759393656) | 11220 | 1.6% | |
| POINT (-87.656066340364 41.9022009180961) | 9388 | 1.3% | |
| POINT (-87.6675682255936 41.8502661710639) | 9047 | 1.3% | |
| POINT (-87.7172194738186 41.8601895923466) | 7933 | 1.1% | |
| POINT (-87.7140020956845 41.8390870085266) | 7482 | 1.1% | |
| POINT (-87.6698374693742 41.8996698963096) | 7187 | 1.0% | |
| POINT (-87.7234524820666 41.95358181896) | 7055 | 1.0% | |
| POINT (-87.7347401601846 41.9243477570064) | 6761 | 1.0% | |
| POINT (-87.6747187652597 41.8995893675262) | 6530 | 0.9% | |
| POINT (-87.7633999111184 41.9540281621501) | 6386 | 0.9% | |
| POINT (-87.6714490286271 41.9192070176705) | 6376 | 0.9% | |
| POINT (-87.6541250863618 41.8716914509744) | 6369 | 0.9% | |
| POINT (-87.6769992950319 41.9147877430097) | 6139 | 0.9% | |
| Other values (268) | 177836 | 25.0% | |
| (Missing) | 97916 | 13.8% |
Frequencies of value counts
Unique
| Unique | 4 ? |
|---|---|
| Unique (%) | < 0.1% |
Histogram of lengths of the category
Length
| Max length | 45 |
|---|---|
| Median length | 42 |
| Mean length | 36.42841347 |
| Min length | 3 |
Most occurring characters
| Value | Count | Frequency (%) | |
| 8 | 2656229 | 10.3% | |
| 7 | 2175268 | 8.4% | |
| 6 | 2092122 | 8.1% | |
| 4 | 1964583 | 7.6% | |
| 1 | 1948524 | 7.5% | |
| 5 | 1625580 | 6.3% | |
| 9 | 1620567 | 6.3% | |
| 2 | 1602379 | 6.2% | |
| 3 | 1317323 | 5.1% | |
| 0 | 1243338 | 4.8% | |
| 1225846 | 4.7% | ||
| . | 1225846 | 4.7% | |
| P | 612923 | 2.4% | |
| O | 612923 | 2.4% | |
| I | 612923 | 2.4% | |
| N | 612923 | 2.4% | |
| T | 612923 | 2.4% | |
| ( | 612923 | 2.4% | |
| - | 612923 | 2.4% | |
| ) | 612923 | 2.4% | |
| n | 195832 | 0.8% | |
| a | 97916 | 0.4% |
Most occurring categories
| Value | Count | Frequency (%) | |
| Decimal Number | 18245913 | 70.5% | |
| Uppercase Letter | 3064615 | 11.8% | |
| Space Separator | 1225846 | 4.7% | |
| Other Punctuation | 1225846 | 4.7% | |
| Open Punctuation | 612923 | 2.4% | |
| Dash Punctuation | 612923 | 2.4% | |
| Close Punctuation | 612923 | 2.4% | |
| Lowercase Letter | 293748 | 1.1% |
Most frequent Lowercase Letter characters
| Value | Count | Frequency (%) | |
| n | 195832 | 66.7% | |
| a | 97916 | 33.3% |
Most frequent Uppercase Letter characters
| Value | Count | Frequency (%) | |
| P | 612923 | 20.0% | |
| O | 612923 | 20.0% | |
| I | 612923 | 20.0% | |
| N | 612923 | 20.0% | |
| T | 612923 | 20.0% |
Most frequent Space Separator characters
| Value | Count | Frequency (%) | |
| 1225846 | 100.0% |
Most frequent Open Punctuation characters
| Value | Count | Frequency (%) | |
| ( | 612923 | 100.0% |
Most frequent Dash Punctuation characters
| Value | Count | Frequency (%) | |
| - | 612923 | 100.0% |
Most frequent Decimal Number characters
| Value | Count | Frequency (%) | |
| 8 | 2656229 | 14.6% | |
| 7 | 2175268 | 11.9% | |
| 6 | 2092122 | 11.5% | |
| 4 | 1964583 | 10.8% | |
| 1 | 1948524 | 10.7% | |
| 5 | 1625580 | 8.9% | |
| 9 | 1620567 | 8.9% | |
| 2 | 1602379 | 8.8% | |
| 3 | 1317323 | 7.2% | |
| 0 | 1243338 | 6.8% |
Most frequent Other Punctuation characters
| Value | Count | Frequency (%) | |
| . | 1225846 | 100.0% |
Most frequent Close Punctuation characters
| Value | Count | Frequency (%) | |
| ) | 612923 | 100.0% |
Most occurring scripts
| Value | Count | Frequency (%) | |
| Common | 22536374 | 87.0% | |
| Latin | 3358363 | 13.0% |
Most frequent Latin characters
| Value | Count | Frequency (%) | |
| P | 612923 | 18.3% | |
| O | 612923 | 18.3% | |
| I | 612923 | 18.3% | |
| N | 612923 | 18.3% | |
| T | 612923 | 18.3% | |
| n | 195832 | 5.8% | |
| a | 97916 | 2.9% |
Most frequent Common characters
| Value | Count | Frequency (%) | |
| 8 | 2656229 | 11.8% | |
| 7 | 2175268 | 9.7% | |
| 6 | 2092122 | 9.3% | |
| 4 | 1964583 | 8.7% | |
| 1 | 1948524 | 8.6% | |
| 5 | 1625580 | 7.2% | |
| 9 | 1620567 | 7.2% | |
| 2 | 1602379 | 7.1% | |
| 3 | 1317323 | 5.8% | |
| 0 | 1243338 | 5.5% | |
| 1225846 | 5.4% | ||
| . | 1225846 | 5.4% | |
| ( | 612923 | 2.7% | |
| - | 612923 | 2.7% | |
| ) | 612923 | 2.7% |
Most occurring blocks
| Value | Count | Frequency (%) | |
| ASCII | 25894737 | 100.0% |
Most frequent ASCII characters
| Value | Count | Frequency (%) | |
| 8 | 2656229 | 10.3% | |
| 7 | 2175268 | 8.4% | |
| 6 | 2092122 | 8.1% | |
| 4 | 1964583 | 7.6% | |
| 1 | 1948524 | 7.5% | |
| 5 | 1625580 | 6.3% | |
| 9 | 1620567 | 6.3% | |
| 2 | 1602379 | 6.2% | |
| 3 | 1317323 | 5.1% | |
| 0 | 1243338 | 4.8% | |
| 1225846 | 4.7% | ||
| . | 1225846 | 4.7% | |
| P | 612923 | 2.4% | |
| O | 612923 | 2.4% | |
| I | 612923 | 2.4% | |
| N | 612923 | 2.4% | |
| T | 612923 | 2.4% | |
| ( | 612923 | 2.4% | |
| - | 612923 | 2.4% | |
| ) | 612923 | 2.4% | |
| n | 195832 | 0.8% | |
| a | 97916 | 0.4% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| Trip ID | Start Time | End Time | Trip Distance | Trip Duration | Accuracy | Start Census Tract | End Census Tract | Start Community Area Number | End Community Area Number | Start Community Area Name | End Community Area Name | Start Centroid Latitude | Start Centroid Longitude | Start Centroid Location | End Centroid Latitude | End Centroid Longitude | End Centroid Location | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 758e9d21-609f-5479-8e2c-5e8f64258202 | 07/01/2019 05:00:00 PM | 07/01/2019 05:00:00 PM | 421 | 3 | 1 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 1 | ff33490c-254a-5af2-9315-d6b2a45b07f7 | 06/29/2019 06:00:00 PM | 06/29/2019 06:00:00 PM | 6318 | 31 | 1 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 2 | f8a25729-e853-40f3-9200-7eea9f9c45f2 | 09/16/2019 01:00:00 PM | 09/16/2019 01:00:00 PM | 77 | 732 | 10 | NaN | NaN | NaN | 25.0 | NaN | AUSTIN | NaN | NaN | NaN | 41.894101 | -87.763112 | POINT (-87.7631118242259 41.8941012961134) |
| 3 | 11d42b99-e839-346c-11d4-2b99e839346c | 06/24/2019 07:00:00 PM | 06/24/2019 07:00:00 PM | 917 | 359 | 10 | NaN | NaN | 25.0 | 25.0 | AUSTIN | AUSTIN | 41.894101 | -87.763112 | POINT (-87.7631118242259 41.8941012961134) | 41.894101 | -87.763112 | POINT (-87.7631118242259 41.8941012961134) |
| 4 | 0c226130-0fa6-518f-8fe6-219b9fa5f42f | 07/12/2019 07:00:00 PM | 07/12/2019 07:00:00 PM | 0 | 218 | 0 | NaN | NaN | 21.0 | 21.0 | AVONDALE | AVONDALE | 41.938666 | -87.711211 | POINT (-87.7112106378686 41.938665887698) | 41.938666 | -87.711211 | POINT (-87.7112106378686 41.938665887698) |
| 5 | 11ed0125-e5b6-6ab6-11ed-0125e5b66ab6 | 07/13/2019 03:00:00 PM | 07/13/2019 03:00:00 PM | 112 | 424 | 10 | NaN | NaN | 21.0 | 21.0 | AVONDALE | AVONDALE | 41.938666 | -87.711211 | POINT (-87.7112106378686 41.938665887698) | 41.938666 | -87.711211 | POINT (-87.7112106378686 41.938665887698) |
| 6 | 1690f90b-0a0a-402d-b493-ed351d7e0946 | 07/20/2019 06:00:00 PM | 07/20/2019 06:00:00 PM | 1725 | 1141 | 10 | NaN | NaN | 21.0 | 21.0 | AVONDALE | AVONDALE | 41.938666 | -87.711211 | POINT (-87.7112106378686 41.938665887698) | 41.938666 | -87.711211 | POINT (-87.7112106378686 41.938665887698) |
| 7 | 37dc7e7f-0e46-4bf6-b07d-8396fe3f0ccd | 08/20/2019 04:00:00 PM | 08/20/2019 04:00:00 PM | 0 | 7 | 10 | NaN | NaN | 21.0 | 21.0 | AVONDALE | AVONDALE | 41.938666 | -87.711211 | POINT (-87.7112106378686 41.938665887698) | 41.938666 | -87.711211 | POINT (-87.7112106378686 41.938665887698) |
| 8 | 6c4daee2-7820-4c10-ba20-136cfa399e86 | 09/26/2019 08:00:00 AM | 09/26/2019 08:00:00 AM | 0 | 601 | 10 | NaN | NaN | 21.0 | 21.0 | AVONDALE | AVONDALE | 41.938666 | -87.711211 | POINT (-87.7112106378686 41.938665887698) | 41.938666 | -87.711211 | POINT (-87.7112106378686 41.938665887698) |
| 9 | b1a423cc-4544-4edc-9cdf-857a952d98c2 | 06/30/2019 08:00:00 PM | 06/30/2019 09:00:00 PM | 1107 | 2519 | 10 | NaN | NaN | 21.0 | 21.0 | AVONDALE | AVONDALE | 41.938666 | -87.711211 | POINT (-87.7112106378686 41.938665887698) | 41.938666 | -87.711211 | POINT (-87.7112106378686 41.938665887698) |
Last rows
| Trip ID | Start Time | End Time | Trip Distance | Trip Duration | Accuracy | Start Census Tract | End Census Tract | Start Community Area Number | End Community Area Number | Start Community Area Name | End Community Area Name | Start Centroid Latitude | Start Centroid Longitude | Start Centroid Location | End Centroid Latitude | End Centroid Longitude | End Centroid Location | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 710829 | ee350f69-d233-5ce3-a339-da8c8c2f6d9e | 07/03/2019 07:00:00 PM | 07/03/2019 07:00:00 PM | 1110 | 367 | 0 | 1.703124e+10 | 1.703124e+10 | 24.0 | 24.0 | WEST TOWN | WEST TOWN | 41.899507 | -87.679600 | POINT (-87.6796003361319 41.8995065454147) | 41.892478 | -87.664739 | POINT (-87.6647387878606 41.8924781700026) |
| 710830 | f740d28b-27ea-4183-af7c-364266c5a405 | 08/04/2019 08:00:00 AM | 08/04/2019 08:00:00 AM | 1555 | 348 | 152 | NaN | NaN | 24.0 | 24.0 | WEST TOWN | WEST TOWN | 41.901207 | -87.676357 | POINT (-87.6763571260391 41.9012067343156) | 41.901207 | -87.676357 | POINT (-87.6763571260391 41.9012067343156) |
| 710831 | e28e355e-b890-5f15-8c82-a09daaa22227 | 06/20/2019 09:00:00 PM | 06/20/2019 09:00:00 PM | 1351 | 1437 | 0 | 1.703124e+10 | 1.703124e+10 | 24.0 | 24.0 | WEST TOWN | WEST TOWN | 41.899507 | -87.679600 | POINT (-87.6796003361319 41.8995065454147) | 41.899422 | -87.684490 | POINT (-87.6844900067498 41.8994219493757) |
| 710832 | f4350bf6-f033-416b-9a12-093676bc0413 | 08/15/2019 06:00:00 PM | 08/15/2019 07:00:00 PM | 566 | 113 | 152 | 1.703124e+10 | 1.703124e+10 | 24.0 | 24.0 | WEST TOWN | WEST TOWN | 41.906707 | -87.684686 | POINT (-87.6846857728006 41.9067070904476) | 41.906023 | -87.675310 | POINT (-87.6753102573397 41.9060233934322) |
| 710833 | f8dd5c1c-fb6c-5d07-8f11-8ab71560feca | 09/17/2019 07:00:00 PM | 09/17/2019 07:00:00 PM | 40 | 65 | 0 | 1.703124e+10 | 1.703124e+10 | 24.0 | 24.0 | WEST TOWN | WEST TOWN | 41.899670 | -87.669837 | POINT (-87.6698374693742 41.8996698963096) | 41.899670 | -87.669837 | POINT (-87.6698374693742 41.8996698963096) |
| 710834 | db29a731-9ab0-5428-8368-bea758cac4fe | 07/24/2019 04:00:00 PM | 07/24/2019 04:00:00 PM | 225 | 147 | 0 | NaN | NaN | 24.0 | 24.0 | WEST TOWN | WEST TOWN | 41.901207 | -87.676357 | POINT (-87.6763571260391 41.9012067343156) | 41.901207 | -87.676357 | POINT (-87.6763571260391 41.9012067343156) |
| 710835 | f644d8ce-a32d-5c1c-ad92-ca01ef86b9f9 | 08/30/2019 04:00:00 PM | 08/30/2019 04:00:00 PM | 595 | 301 | 0 | 1.703124e+10 | 1.703124e+10 | 24.0 | 24.0 | WEST TOWN | WEST TOWN | 41.899670 | -87.669837 | POINT (-87.6698374693742 41.8996698963096) | 41.908376 | -87.670937 | POINT (-87.670937488585 41.9083759393656) |
| 710836 | fe97d758-f9eb-4314-85c0-058d56019e39 | 07/06/2019 03:00:00 PM | 07/06/2019 03:00:00 PM | 1239 | 321 | 152 | 1.703124e+10 | 1.703124e+10 | 24.0 | 24.0 | WEST TOWN | WEST TOWN | 41.892433 | -87.669624 | POINT (-87.6696237770638 41.8924327728614) | 41.899670 | -87.669837 | POINT (-87.6698374693742 41.8996698963096) |
| 710837 | e6687f9e-531f-cff9-1a1f-ae71c7f759b6 | 06/29/2019 11:00:00 PM | 06/29/2019 11:00:00 PM | 1606 | 555 | 10 | NaN | NaN | 24.0 | 24.0 | WEST TOWN | WEST TOWN | 41.901207 | -87.676357 | POINT (-87.6763571260391 41.9012067343156) | 41.901207 | -87.676357 | POINT (-87.6763571260391 41.9012067343156) |
| 710838 | f554df2f-4e4f-5b15-ab56-30199016dcda | 09/05/2019 08:00:00 PM | 09/05/2019 09:00:00 PM | 1656 | 20 | 1 | 1.703124e+10 | 1.703124e+10 | 24.0 | 24.0 | WEST TOWN | WEST TOWN | 41.906023 | -87.675310 | POINT (-87.6753102573397 41.9060233934322) | 41.906710 | -87.665328 | POINT (-87.6653277387058 41.906709710732) |